UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7E8zdd9Y3tVXoCL0UJFcVzhB6ZphqqxjOOV6AmtfH2Q=' 
WHERE 
  key_id = '4767d95e17f2777398174fd40fd9b57ae9de05d70aaa1c9ce9d81fe3a0160f60' 
  AND (
    token = '7E8zdd9Y3tVXoCL0UJFcVzhB6ZphqqxjOOV6AmtfH2Q=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028