UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'HKoYmS5aV5nglo9KNDGK9sV8+M74f4MHavWv5Hwj/IA=' 
WHERE 
  key_id = '02071e82f52d53993d1f0bbb54e2da3cbe9339de59fbcb2c8373864fe7fb4709' 
  AND (
    token = 'HKoYmS5aV5nglo9KNDGK9sV8+M74f4MHavWv5Hwj/IA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021