UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ik3sQfBKLgABste19rRzdPxLNv9xsKAr8gg450FHxn0='
WHERE
key_id = '1a338411a87f6c334f4a9f77b37bf22685e619bbbcb49f61f36b8ef1f0a93735'
AND (
token = 'ik3sQfBKLgABste19rRzdPxLNv9xsKAr8gg450FHxn0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)