UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x/B3t5prYnf1AScb9So1s6dJ0fzClP7eFrXOw3ewSxc='
WHERE
key_id = 'f0d18a43dbdc8224bb53c655b3d760ae091557a30fd6bc3a5fb977a6facac5f7'
AND (
token = 'x/B3t5prYnf1AScb9So1s6dJ0fzClP7eFrXOw3ewSxc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)