UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SyY6xAG8AcdTpQac47fj4lKC4xc9xEx7PC8pOXIycZ4='
WHERE
key_id = '92870efa1c120a64f7d95c1e3b3066471300af36003e784e4b7d6dee7647fa87'
AND (
token = 'SyY6xAG8AcdTpQac47fj4lKC4xc9xEx7PC8pOXIycZ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)