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