UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'JYmUmDig3dWjTH0ZeB9nmwUsox0o1ZrZNy6DbpZroAU=' 
WHERE 
  key_id = 'eab4a3fa3a445365d0a6e9ba394840827c7d63ea701661b2e2119f0ae39acc1c' 
  AND (
    token = 'JYmUmDig3dWjTH0ZeB9nmwUsox0o1ZrZNy6DbpZroAU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00058