UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'wYRei716ANRj5cijXc28Qyg6p8e3lzUju4PfDhlrJSc=' 
WHERE 
  key_id = '0ac10084e946dfaa6e24ad4f4a1c9149cdf42a2a6d6621d87698a9e27693e71f' 
  AND (
    token = 'wYRei716ANRj5cijXc28Qyg6p8e3lzUju4PfDhlrJSc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042