UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fOUbqwY8VuAzKt3eQ57eBr4mejm3EvEPYOQs+n7pnp0='
WHERE
key_id = 'ce3bc2b8807906eb8f7c70bba89d12714b0a4aebaa760a3472f091462ae4fae7'
AND (
token = 'fOUbqwY8VuAzKt3eQ57eBr4mejm3EvEPYOQs+n7pnp0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)