UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oN7Lr86P9qyUuXJObitEkiyKsvyl8S5bHZ0djSjAYIA='
WHERE
key_id = '566daf2e9cb1dc3e5afea6b438fa6bf470fdec881aabc9fa62be6c64b7b89098'
AND (
token = 'oN7Lr86P9qyUuXJObitEkiyKsvyl8S5bHZ0djSjAYIA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)