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