UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 's9Rt+ynNwYhC1+JCO+jdlpvEGMFR3hji9QIts38WXcg=' 
WHERE 
  key_id = '5fc7076f9160518691dad4816a4ea87409b9f972627232e9bbfa7ce1d7eebc49' 
  AND (
    token = 's9Rt+ynNwYhC1+JCO+jdlpvEGMFR3hji9QIts38WXcg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040