UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PsXB1OWtCa1Wzh2fKqD95WTZcW1+5TwlGNTgbqkMdzQ='
WHERE
key_id = '1867c04c9e2d99cfd4d0ae7abcf29b07f865f2ac6847ede4089bf6e1ecc11b3f'
AND (
token = 'PsXB1OWtCa1Wzh2fKqD95WTZcW1+5TwlGNTgbqkMdzQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)