UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Gnd1OYYkI6zUUXrbwfeo1ftJms5RP5WyWY2s3vEhoJY=' 
WHERE 
  key_id = '009b9181cf61a9a1a45be4270d6baf55b8c10acd33c2daa07ad4990d69594cd5' 
  AND (
    token = 'Gnd1OYYkI6zUUXrbwfeo1ftJms5RP5WyWY2s3vEhoJY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035