UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TMhgGzVY2q0h4oLwyDLXW1Z3/UHgNrYnb5MjQLIPlZk='
WHERE
key_id = '6d7062c977f191efda98a8f9887c6f7a939358e3addb12183b974c45b7c008e2'
AND (
token = 'TMhgGzVY2q0h4oLwyDLXW1Z3/UHgNrYnb5MjQLIPlZk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)