UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6YEuhoGJRPtkgnVc+xjnPixgZMkD0AdIpwEQ4pEgKcU='
WHERE
key_id = '227f53f5d7aa87f96972bee428597c8bb559422749686748b92cbc8b76a394b3'
AND (
token = '6YEuhoGJRPtkgnVc+xjnPixgZMkD0AdIpwEQ4pEgKcU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)