UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'uXLFUfs1hF3kOTvC7/1HroXL0eh8vjeLWtlhjoJnsWY=' 
WHERE 
  key_id = 'e371378d4eed89b4fc5e4df860d098bb2dc8e7bbde1002b37498bd411997c06f' 
  AND (
    token = 'uXLFUfs1hF3kOTvC7/1HroXL0eh8vjeLWtlhjoJnsWY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00064