UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'pXOF60PJL28Zh55AVN2MpvBgM0pFNykv7lp+cs0S7bk=' 
WHERE 
  key_id = '2eb129ed8b6a54237c224f0cd6d1c145b50ec9bf65ea8c38dbb3f56f1d9f6f96' 
  AND (
    token = 'pXOF60PJL28Zh55AVN2MpvBgM0pFNykv7lp+cs0S7bk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040