UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'bj7MI/A/gkaVEuFTdmi8BiKUPlwn84/woaebQhhdVOs=' 
WHERE 
  key_id = '2ab040013e639be2efc1c26ba89d98861e481d432cb8e6fe006ee58b2dd8b687' 
  AND (
    token = 'bj7MI/A/gkaVEuFTdmi8BiKUPlwn84/woaebQhhdVOs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027