UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0MBP3XxxKPQoRSvLt35AESRi38yfjJH8S0ODRi0NCJ0='
WHERE
key_id = 'd0bed7d189f2f76200b9d0aadc597ca32531268182f9d0a6a277713e97b1fb10'
AND (
token = '0MBP3XxxKPQoRSvLt35AESRi38yfjJH8S0ODRi0NCJ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)