UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wGV054fEYF0I0KyA6bnpmwuRMonMUEx8ptU24kwl0Vw='
WHERE
key_id = '0d86189981e60affe8137dc258e3a82d7629c58ca4f610b7ab9ee4c61a3dd5e4'
AND (
token = 'wGV054fEYF0I0KyA6bnpmwuRMonMUEx8ptU24kwl0Vw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)