UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9oqeOsEUCMuMOJNlST3cef+Lh3QlwVStbbs4oa7bHPw='
WHERE
key_id = '14afbe8a2fa362ffa66c1f3742096f623551d716fef0a67620685f365fbcb970'
AND (
token = '9oqeOsEUCMuMOJNlST3cef+Lh3QlwVStbbs4oa7bHPw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)