UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'meYGjy6K5NhYsfvEMpfXrXC1JVzbMJes5pegNRzmNZE='
WHERE
key_id = '40e0dd2f3882707f4f14c88c45b54447d9e792582aa8fcec98c5b83a4ce582f1'
AND (
token = 'meYGjy6K5NhYsfvEMpfXrXC1JVzbMJes5pegNRzmNZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)