UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WdTR2U+zsw4tKRLjRps8Ac6muM0Xz+q00mt6jyAT3l8='
WHERE
key_id = '046d1cafea7fdb145f09e20352ab0f82e1b08f97434c651f4b85faaa29f0e2f1'
AND (
token = 'WdTR2U+zsw4tKRLjRps8Ac6muM0Xz+q00mt6jyAT3l8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)