UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/l8ZxQy58WAuJQuoP0vkeOzDXJCCFi6Tm8pANAEsfkw='
WHERE
key_id = 'ec9bb617b4192dcb62304e8e43e18ccd4fbc8982e8a32133ff6abd79c9130ece'
AND (
token = '/l8ZxQy58WAuJQuoP0vkeOzDXJCCFi6Tm8pANAEsfkw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)