UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KAPjS27j8P9k4yF1VX14IF2uOUwhjGwstDcnRb7XU3A='
WHERE
key_id = '0dd2f04899f89115dce115eaf0afe8fb54754e00b6a64f367d15a48f78135c13'
AND (
token = 'KAPjS27j8P9k4yF1VX14IF2uOUwhjGwstDcnRb7XU3A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)