UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cHAWanDZbI8h4HXyA8Im8j2QD67d0mP5oPvedpRCbzY='
WHERE
key_id = '49496eb663e4318944f0ba09384ea0cdbe78f84ce45f6ec6380273f743afee4f'
AND (
token = 'cHAWanDZbI8h4HXyA8Im8j2QD67d0mP5oPvedpRCbzY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)