UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0eVEkt4vkXrK2HKt/Y84m5BirZbfD65Nfew4l8ErwTA='
WHERE
key_id = '9912aae3149f9cc0133e03f182f2070915635d6b07bccee9c87a502570a3a42f'
AND (
token = '0eVEkt4vkXrK2HKt/Y84m5BirZbfD65Nfew4l8ErwTA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)