UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'P/HdY3Hp4/f2uMXx2U3/CN++aF/eplhsP+XVtZ7j0jM=' 
WHERE 
  key_id = '48bac6a8ba617b3afb9e80bc74ab6d371edc8ea35f212433216e4ec86af605de' 
  AND (
    token = 'P/HdY3Hp4/f2uMXx2U3/CN++aF/eplhsP+XVtZ7j0jM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00078