UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XBsW1By5YauVRTSbU8YYPw7U2n5hJo3K7lKxnVoJwwY='
WHERE
key_id = 'aabc3301bc6b87553747999e924174a8813ac2c5e7fa5526cf144b8512652175'
AND (
token = 'XBsW1By5YauVRTSbU8YYPw7U2n5hJo3K7lKxnVoJwwY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)