UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'OQxce1BeUy9p1ld6QlPVL03XKgeMz6sDr0D+q+E4WTI=' 
WHERE 
  key_id = '57b56c1789599feb86625a3ae92852b1a71f8f666a3572280e61632e23a5eaea' 
  AND (
    token = 'OQxce1BeUy9p1ld6QlPVL03XKgeMz6sDr0D+q+E4WTI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046