UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P7BQsL9y2oSY8Mn2YiRdka5eE5tYTWj0yOWcD8hspJI='
WHERE
key_id = 'c6d458166714a6ac17920d2703c519ef911fb4a65c1ae389960de11af69a85bf'
AND (
token = 'P7BQsL9y2oSY8Mn2YiRdka5eE5tYTWj0yOWcD8hspJI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)