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

Query time 0.00024