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

Query time 0.00051