UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'SD3zHLLENgf5Mz9nZIwV29767IayzuCC9LndFNbcpJk=' 
WHERE 
  key_id = '991c6e0098a8f9c153dfefe18f5335f5c1083f5571e8af3610bdcdb2a56d8667' 
  AND (
    token = 'SD3zHLLENgf5Mz9nZIwV29767IayzuCC9LndFNbcpJk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044