UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oSwwQcCt134J+ZzYk0vStyKB56xtUGyGSbvmULy6HLc='
WHERE
key_id = 'f4b1a19b27aa5b581736c22a3a3296f2df5097dc6f19569d2c592f9a23d3d1e1'
AND (
token = 'oSwwQcCt134J+ZzYk0vStyKB56xtUGyGSbvmULy6HLc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)