UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A/VwUCf/eUuthEjSFbQkl4KvQs294OQW/Red2yHX2wg='
WHERE
key_id = 'b15a4dfa8f35ad27b5413994be01113be41c9d6e1fef5973b2039aaced56a04b'
AND (
token = 'A/VwUCf/eUuthEjSFbQkl4KvQs294OQW/Red2yHX2wg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)