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