UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PDXo7SLt1hi3fg8y4JnObfpxLZkSaD+KS51Aim6SsvA='
WHERE
key_id = 'a3588fcc688b80c7e870913fe5d81a54879ec6cf6a56342ee5851be4a9e71a31'
AND (
token = 'PDXo7SLt1hi3fg8y4JnObfpxLZkSaD+KS51Aim6SsvA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)