UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7sOGI6Ui5PtQJsJuVT3dEyq5Sw6TZendTtMI/5pLhr4='
WHERE
key_id = '543e980aa6a18c4e03c6265f2c098968eb8f07b1e4210b463cb7a3b5503d4a8f'
AND (
token = '7sOGI6Ui5PtQJsJuVT3dEyq5Sw6TZendTtMI/5pLhr4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)