UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NRbzZbMZnENcKpZ1vUpsfDBw7x01vgh/u186C/zx4fk='
WHERE
key_id = '1e6a545c839aa56dd148d86a2841727d52bf5176d9b47af7449a61742aaafd3c'
AND (
token = 'NRbzZbMZnENcKpZ1vUpsfDBw7x01vgh/u186C/zx4fk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)