UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4Xsd4tlNeF0/x0pOLLbS9L7vDRe4QASHC8RVZuF6cas=' 
WHERE 
  key_id = 'd429fb496e1e3804041e0c735fcd76c47b541180fa8e21488552f530bf04b2f7' 
  AND (
    token = '4Xsd4tlNeF0/x0pOLLbS9L7vDRe4QASHC8RVZuF6cas=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00055