UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mTNHsAG6BAbKpJLjYwXVlj3UIdBx0lV57m5wSd+VSGA='
WHERE
key_id = '824a1af14d5c07c771687bc4f1c06d5562a6f41fb476222135116d631ca0d0a6'
AND (
token = 'mTNHsAG6BAbKpJLjYwXVlj3UIdBx0lV57m5wSd+VSGA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)