UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FqmrPe5Di+BQNLPt06yZSwTG/OTvf/XpsIAoDSfU4g8='
WHERE
key_id = 'c6ba5e0ce8512e316bcd139fbfd261df869fb76dd5b25a7c1799f75f4495b46a'
AND (
token = 'FqmrPe5Di+BQNLPt06yZSwTG/OTvf/XpsIAoDSfU4g8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)